Install, monitor, and maintain PostgreSQL, MSSQL, & Oracle software, implement monitoring and alerting, implement backup and recovery processes, provide system and SQL performance tuning and assist in business process integration with various data sources.
Develop processes for optimizing database security.
Fulfills user requests ranging from access control, backup, restore, refresh to non-production to performance tuning.
Provides online & on call coverage for production support and administration of PostgreSQL, MSSQL, & Oracle.
Develop processes for optimizing database security.
Set and maintain database standards.
Manage database access.
Performance tuning of database systems.
Install, upgrade, and manage database applications.
Diagnose and troubleshoot database errors.
Recommend and implement emerging database technologies.
Create and manage database reports, visualizations, and dashboards.
Create automation for repeating database tasks.
Implement and act in accordance with Organization\'s information security and privacy policies.
Protect assets from unauthorized access, disclosure, modification, destruction or interference.

Core Responsibilities: Administrator -

Installation, Configuration and Administration of Oracle RAC & Non-RAC Databases.
Installation, Configuration and Administration of Microsoft SQL Server Enterprise Edition 2014.
Troubleshoot database problems in both production and non-production environments; lead RCA process and ensure all fixes are fully implemented, collaborate across infrastructure teams to determine RCA.
Oracle EBS Cloning Application and Database.
Review database design and integration of systems provides backup recovery and make recommendations regarding enhancements and/or improvements.
DR site planning and setups for Database Servers.
Create Maintains and Update Backup and Recovery strategies of Database Management System.
Utilize Multiple Monitoring and Diagnostics tools to identify/resolve database performance issues.
Manage Data Integrity, Security and Privacy in line with company security policies.
Provide technical assistance in the development, maintenance, and DR of databases, supporting the present and associated applications. Implements and maintains smooth operation and physical design of databases.
Installation, Configuration and Administration of Production & UAT environment.
Formulates policies, procedures, and standards relating to database management, and monitors transaction activity and utilization.
Health Check of Application & Databases Servers as per policy to ensure correct usage.
Oracle DB cloning, backups, and Disaster recovery.
Import/Export, Hot & Cold Backups using Oracle RMAN/Data pump utility for backups.
Future capacity planning in graph form for the management to pro-active manages hardware resources for all the databases.
Adding jobs to CRON as needed Linux based Servers.
Collaborate with business units, application and administration teams to design, size and plan new environments.
Applying new Oracle Patches and provide DBA Support to all Databases.
Maintaining up to date documentation concerning the Technical Strategies & Standards Procedures.
Working with Oracle Technical Support to resolve any Oracle related problems and contact Oracle worldwide support Meta-Link if required.
Maintaining and Monitoring Retention Policy.
Provide 24x7 Operational Support.

Core Responsibilities: Developer -

To take the lead in developing and maintaining an internal reporting service, including the college\'s data dashboard, presenting highly accurate data to meet the user\'s needs.
Work innovatively keeping abreast of latest technologies relevant to the role as well as to cultivate long-term strategic goals for MIS reports in conjunction with end users, managers, and other stakeholders.
Maintain the importing, linking and exporting of data integration across various systems.
To maintain and closely monitor the accuracy and credibility of the data used for business intelligence.
Develop reporting tools to extract and present data from applications as required.
Developed BI Portal installation of SSRS and Report creating using SQL Report Builder Tool.
Automated the extraction of daily reports for ease of other departments. .
Database Deadlocks deduction and prevention.
Jasper Reports development, management and implementation.
Writing and maintaining T-SQL queries, views, functions, joins, and stored procedures used by reports according to the BRD (Business Requirements Document).
Work on all reporting requirements of SBP (State Bank of Pakistan).
Writing and tuning complex SQL statements, complex joins, M-views and sub-queries.

Investigate, evaluate and settle claims, applying technical knowledge and human relations skills to effect fair and prompt disposal of cases and to contribute to a reduced loss ratio.
Adjust reserves or provide reserve recommendations to ensure that reserve activities are consistent with corporate policies.
Resolve complex, severe exposure claims, using high service oriented file handling.
Examine claims investigated by insurance adjusters, further investigating questionable claims to determine whether to authorize payments.
Enter claim payments, reserves and new claims on computer system, inputting concise yet sufficient file documentation.
Maintain claim files such as records of settled claims and an inventory of claims requiring detailed analysis.

Create SQL database structures that integrate with Android applications and web interfaces.
Ensure applications are properly integrated with Android APIs.
Wrote clean, clear, efficient, well-tested and maintainable code.